由 macro 发布于: 2001-03-05 19:37

Types of Tablespaces

The DBA creates tablespace for increased control and ease of maintenance.The oracle server perceives two types of tablespaces: SYSTEM and all others.

SYSTEM tablespace:

1.created with the database
2.Required in all database
3.Contains the data dictionary,including stored propram units
4.Contains the SYSTEM rollback segment
5.Should not contain user data,although it is allowed

NON-SYSTEM Tablespaces:

1.Enable more flexibility in database administrator
2.Separate rollback,temporary,application data,and application index segments
3.Separate data by backup requirements
4.Separate dynamic and static data
5.Control the amount of space allocated to user's objects
__________________

谢谢你抽时间看我的发言，

Macro Zeng

==================================

我正在学习 Oracle ,坚持每天写读书笔记